use[Yacht Rental]
GO

/****** ray Object:  Table [dbo].[Transactiondetails]   Script Date: 9/29/2017 12:55:22 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Transactiondetails](
	[Transactiondetailsid] [int] IDENTITY(1,1) NOT NULL,
	[Decription] [varchar](200) NOT NULL,
	[transactionid] int NOT NULL,
	[totalamount] [int] NULL,
	[status] varchar(50),--lookupvalue
	[paymentamount] int ,
    [createddate][datetime],
	[updatedatetime][datetime],
	[processingdate][datetime],
	[rowstatus] bit
 CONSTRAINT [PK__Transactiondetails__093020171250] PRIMARY KEY CLUSTERED 
(
	[Transactiondetailsid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
